What is ACID property of transaction in SQL Server?
What is ACID property of transaction in SQL Server?
33715-Nov-2021
Updated on 15-Nov-2021
Home / DeveloperSection / Forums / What is ACID property of transaction in SQL Server?
What is ACID property of transaction in SQL Server?
Steilla Mitchel
15-Nov-2021ACID Property of Transaction in SQL Server:
Transaction:
A transaction is a group of operations that are treated as just one logical operation.
Example: When we withdraw money from our bank account or deposit money in the bank account.
ACID Properties: Transaction has four properties which we call ACID Properties.
1- Atomicity.
2- Consistency.
3- Isolation.
4- Durability.
Atomicity: When the transaction is completed in a single step then the transaction is atomic.
Consistency: When the transaction takes place, the database is consistence from one state to another.
Isolation: When two or more transactions are executed simultaneously, then one transaction does not affect the other transaction.
Durability: When a transaction is completely completed then the changes that take place stay in the system permanently. That is, the transaction should be durable.